How to: Set date field to default to current system date for all new records.
Solution:
In the Forms Design view, use the 'Default Value' property box in the property sheet to default to the current date.
1) If the Database window is not activated, activate the Database window.
2) Click the 'Forms' tab in the Database window.
Forms tab
3) Select the desired form from the list. (The selected form is highlighted.)
4) Click 'Design'. (The selected form appears in Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Properties'. (The property sheet appears.)
6) Click on the desired control in the form. (Handles appears around the selected control.)
NOTE: The control must have a data type of Date/Time in the underlying table.
7) Click the 'Data' tab in the property sheet.
8) Click on the 'Default Value' box. (A blinking cursor appears.)
9) Type 'Date ()' in the 'Default Value' box.
NOTE: The current date will appear for every new record entered in the form.
10) Select the 'File' menu and select 'Save' to save changes to the form.
